home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d3
/
pctyp2_c.arc
/
PCTDOC1.EXE
/
lha
/
CHAP15.TXT
< prev
next >
Wrap
Text File
|
1989-04-21
|
9KB
|
169 lines
subject: IMPORTING
overview: IMPORT is the process of bringing data from other
sources into your PC-Type II text file. If you have not
defined an import data source via the Configuration
process of PC-Type II, you must define the source and
record selection criteria which begins with the menu
shown below. (See the "Import Source Definition" and
"Import Selection Definition" sections in the
Configure section of this manual).
┌────────────────┐
│IMPORT options: │
╞════════════════╡
│ (0) PC-File+ │
│ (1) PC-FILE:dB │
│ (2) PC-Calc+ │
│ (3) Mail │
│ (4) ASCII-L │
│ (5) ASCII-C │
│ (X) Exit │
└────────────────┘
After the import data has been defined, data
importation begins. This import process is described
in this section. Since the terminology is based upon
the import definition, we recommend you refer to the
Configuration references cited above before
continuing. When all the data you want has been
imported, PC-Type II returns to its normal edit mode.
If you define the import criteria from the "(I)mport"
option of the Main Menu, the information will neither
be saved in a .IMP file nor referenced in a .PRO file.
You must go to the Configure option of PC-Type II to save
the import information to disk via the "(F)ile
handling" option to create the .IMP file. To have
that file referenced in your .PRO file, you must
answer Y to the question "Save data to .PRO file?".
If you defined the import criteria within the
Configuration section of PC-Type II, the .IMP file is
created at your request when saving the updated .PRO
file. It is only necessary to create a .IMP file if
you plan to use the same import rules in multiple
PC-Type II sessions.
When PC-Type II begins, if the .IMP file is referenced in
your .PRO file, it will be loaded automatically. When
you select the "(I)mport" option, you are given the
option to modify the "search criteria" and the fields
of data in a record to import. After any
modifications have been made, you can begin importing
data into your text file.
175
subject: RETRIEVING IMPORT DATA
discussion: PC-Type II begins the process of retrieving data by
moving through the data source and finding records
which match your selection criteria. When a match is
found, the fields to be imported you are displayed on
the screen like:
┌───────────────────────────────┐
│ NAME Cat~Garfield │
│ STREET 123 Feline Court │
│ CITY Lyons │
│ STATE CA │
│ ZIP# 90014 │
│ │
│ Record 2 of 11 │
└───────────────────────────────┘
and you are asked:
Import? Press Y or N
Esc: If you press Esc at this point, (or at any point in
the import process), importing is terminated and you
will be immediately returned to the normal PC-Type II
edit mode.
N: If you respond by pressing N, the source file will
continue to be scanned until another record meets the
selection criteria. It data will then be displayed
and you will be asked again if you wish to import this
data.
Y: If you respond by pressing Y, the data displayed will
be inserted into your source file and you will be
asked:
Select another? Press Y or N
If you answer by pressing N, the import process is
terminated. If you answer by pressing Y, then the
source file will again be searched for another match.
Finally, if no more matches are found in the source
file, the message:
At End of File. Press a key to continue ...
is displayed and you will be returned to the standard
PC-Type II edit mode. The data you imported will be
visible on your PC-Type II screen and your cursor will be
below the information just imported.
NOTE:ïIn the example, "Cat~Garfield" will be imported
ïas "Garfield Cat". PC-Type II flips data
ïsurrounding the tilde character.
176
field names: Note the sample screen on the preceding page which is
displayed when you are asked if you want to import the
data. If you defined a PC-File+ or PC-File:dB data
source, the field names are displayed to the left of
the data. With PC-Calc+ and ASCII file data, field
names are not available. In these cases, the names
"Fieldi", ... "Fieldn" will be displayed instead.
selection: The Command Line will display the selection formula
being used to find record matches within the source
file. If you opted for the "(A)ll" selection
criteria, the Command Line will be blank.
inserting data: Except for a special PC-Calc+ import option (described
below), all data which is imported is brought into
your PC-Type II text file as a new line for each import
field. (Empty fields of data are ignored.) After all
the selected fields for a given record have been
brought into your file, a blank line is inserted which
separates multiple records of data which may have been
imported.
The lines of imported data will be inserted in your
text immediately below the line on which the cursor
was located when the "(I)mport option was invoked.
PC-Calc+: A special import option exists for PC-Calc+. Suppose
you defined the data to be imported to be in the range
B5:H100. From PC-Calc line 5 and continuing through
line 100, fields in columns B through H are inspected
to see if they match the selection criteria imposed.
If they do, and you opted to import the data in
columns D, E, G and H, then the four fields in each
row may be imported into one row (each field being
separated by a Tab character), or into four lines with
each field on its own line. The Tab character is
inserted so that you can set your margins and reformat
the area to move the elements into the desired
locations.
┌──────────────────┐ If you want all cells from one
│Question: │ PC-Calc+ line to be placed in
╞══════════════════╡ one PC-Type II line, answer N to
│One cell per line?│ the window at the left which is
│Press Y or N │ asked during import definition.
└──────────────────┘
┌───────────────────────────┐ This unique
│Question: │ PC-Calc+ question
╞═══════════════════════════╡ lets you import all
│Bring in all rows in range?│ the lines without
│Press Y or N │ stopping and asking
└───────────────────────────┘ at each line.
177